home *** CD-ROM | disk | FTP | other *** search
/ SPACE 1 / SPACE - Library 1 - Volume 1.iso / apps / 150 / sheet14.doc < prev    next >
Text File  |  1988-03-20  |  7KB  |  160 lines
  1. 0660103030566
  2. 1Sheet14.DocBy Chor-ming Lung3-19-1988
  3. 2page #
  4. 9[....................................................]
  5. êDeskaccessoryversionÇ:
  6.      Youhavetopress<HELP>keytogetthepseudomenuforthe
  7. deskaccessoryversionofSHEET.
  8.      Manymenuoptionscanbeselectedbyusing<Controlkey>and
  9. theoperationsbetweenPRGandACCarethesame.Thedesk
  10. accessoryversionhasonlyonewindow,nocommandsandthe
  11. resourcefileisembeddedinside(itmeansCALC.RSCisnot
  12. requiredandthatiswhytheprogramsizeofACCversionisbigger
  13. thanthePRGversion).
  14.  
  15. êNewfeaturesforversion1.4Ç:
  16.      TheonlythingthatIchangedistheuserinterface.Itis
  17. necessaryforACCusersanditissimplertooperatewith.
  18.  
  19. êChangethewidthofasinglecolumnÇ:
  20.      Therearetwowaystodothis.Youcaneitherselectmenu
  21. item"Width"orusetheCOLUMNBAR(theoneunderthelineeditor)
  22. andmouse.
  23.      Youmaynoticethereisasmallwhitegapbetweeneachcolumn
  24. reference.TochangethewidthofCOLUMNA
  25. -movethemousetothewhitegapbetweenCOLUMNA
  26. andB,
  27. -presstheleftmousebutton(donotreleaseit)
  28. -toexpandthecolumnwidth,dragthemousetoright
  29. andreleasethebutton
  30. -toshrinkthecolumnwidth,dragthemousetoleft
  31. andreleasethebutton.
  32. -ifyourcolumnwidthis1characterwide,thenthe
  33. columnreferencewillpushonthenextcolumn.
  34.  
  35.  
  36. êBLOCKSÇ:
  37. Eachtime,youcandefinedupto18blocksforCELLSERASE,
  38. REFORMAT,COPYandMOVE;ROW/COLUMNinsertionanddeletion.
  39.      COPYandMOVEonlytakes2blocks.Ifmoreorlessthan2
  40. blockshavebeenselected,theysimplyrefusetodoanything(by
  41. theway,theCOPYandMOVEcommandsdescribedinversion1.3will
  42. notwork.Iwasforcedtouploadversion1.3becauseauser
  43. toldmehefoundversion1.2wasnotworkingproperly.Thebugis
  44. duetoIrewrotetheredrawroutinefor4windowssupport.After
  45. thescreenredrawing,Isimplyforgottoresettheclippedarea
  46. foroutputtocurrentworkingarea.Thatiswhythesystemseems
  47. beinglockedup.Youcanbypassthisbugbychangingwindowsize.
  48. Ithinkusersmaybemorehappytouseafixedversionthanusing
  49. itinconveniently.Thatiswhyyouseeversion1.3andthatisthe
  50. wayItesttheCOPYandMOVEcommands.Ihavetosaysorryto
  51. thosewhodownloadedversion1.2and1.3).
  52.      
  53. êBlockselectionÇ:
  54.      ThefollowingisthestepsforselectingblockB5..C14:
  55. üStartingablockÇ:
  56. -movethemousecursorwithinthecellB5
  57. -press<Control>keyandtheleftmousebutton
  58. simoutaneously
  59. -äIfyoudonotchoosestoppingcell,thecurrent
  60. startingcellwillbethestoppingcell.
  61. ÇüStoppingablockÇ:
  62. -movethemousercursorwithinthecellC14
  63. -press<Shift>keyandtheleftmousebutton
  64. simoutaneously
  65. -äYoucanalwayschangethelaststoppingcellbythe
  66. abovemethod.
  67. Ç
  68.      üIfyouaredefiningthefirstblockÇ,youcanusetheabove
  69. methodor
  70. -movethemousecursorwithinthecellB5
  71. -presstheleftmousebuttonanddraguntilyou
  72. reachcellC14
  73. -releasemousebutton.
  74.  
  75.  
  76. êRow/ColumnselectionÇ:
  77.      ThefollowingisthestepsforselectingCOLUMND:
  78. -movethemousecursorontopoftheCOLUMNBARwith
  79. COLUMNreferenceD
  80. -pressthemousebuttononce.
  81.      üUsethesimilarproceduretochoosearowÇ.
  82.  
  83.  
  84. êDe-selectingblocksÇ:
  85.      Selectinganycellbymouseclickwithout<Control>/<Shift>
  86. keywillde-selectalltheblocksbeingselected.
  87.  
  88.  
  89. êMultiplerangesERASEÇ:
  90.      Toeraseseveralnon-contiguousblocks:
  91. -selectblocksusingaboveäBlockselectionÇmethod
  92. -Press<ControlE>orchoosemenuitemEraseunder
  93. CELLS
  94.  
  95.  
  96. êMultiplerangesREFORMATÇ:
  97.      Toreformatseveralnon-contiguousblocks:
  98. -selectblocksusingaboveäBlockselectionÇmethod
  99. -Press<ControlR>orchoosemenuitemReformat
  100.  
  101.  
  102. êCOPYoneblocktoanotherblockÇ:
  103. Tocopyoneblocktoanotherblock:
  104. -select2blocks(thefirstblockisthesource
  105. blockandthesecondisdestinationblock)
  106. -Press<ControlC>orchoosemenuitemCopy
  107. üNoteÇ:Ablockcanbesinglecell(A2),partofacolumn
  108. (A1..A20),partofarow(B20..E20)orarange
  109. (A4..C10).Thefollowingdescribeshowtheprogram
  110. handledifferenttypesofblockCOPY.Sourceisthe
  111. firstblockanddestinationisthesecondblock.
  112. ResultistherangesizechosenbyCOPY.
  113.  
  114. SourceDestinationResult
  115. ---------------------------------------------------------
  116. Singlecellanykindofblockthelargestrange
  117. columnreference    anykindofblockthelargestrange
  118. rowrefereneceanykindofblockthelargestrange
  119. Arangereferenceanykindofblockthesourcerange
  120.  
  121. Example:
  122. -IfyouwanttoCOPYC1toC2..C20
  123. *ControlandmouseclickoncellC1
  124. *ControlandmouseclickoncellC2
  125. *ShiftandmouseclickoncellC20
  126. *ControlC
  127.  
  128. êMoveablockÇ:
  129.      OperationsissimilartoCOPY.TherangesizechosenbyMOVE
  130. istherangesizeofsourceblock.
  131.  
  132.  
  133. êRowinsertion/deletionÇ:
  134. -choosetherowbyäRow/ColumnselectionÇ
  135. orchoosepartoftherowbyäblockselectionÇ
  136. -choosemenuitemInsert/DeletefrommenutitleRow/Col
  137.  
  138.  
  139. êColumninsertion/deletionÇ:
  140. -choosethecolumnbyäRow/ColumnselectionÇ
  141. orchoosepartofthecolumnbyäblockselectionÇ
  142. -choosemenuitemInsert/DeletefrommenutitleRow/Col
  143.  
  144.  
  145. êApologyÇ:
  146.      Someone(Stan50)inGEnieaskedmeaboutgraphstuffI
  147. mentionedinearlydocumentation.IsaidIcouldnotrecallIhad
  148. mentionedgraphcapabilityandsimplyrefusedtoaddgraph
  149. functionsinthespreadsheetprogram.
  150.      Inpreparingthisdocumentation,Ireferredtoearly
  151. documentationandfoundIdidmentionit.SorrytoStan50.Tokeep
  152. myword,Istartworkingongraphfunctionsnow.Youcandraw
  153. graphsonnextversion.
  154.  
  155.      Idowantpeoplehappyaboutmyproduct,butthesupportI
  156. gotisnotcomparabletotheeffortImade.So,pleasedodonate
  157. ifyoulikeit.AmIaskingtoomuch?
  158.  
  159.  
  160.